ALTER TABLE [dbo].[CLASSIF_FISCAL_IMPOSTO]
ADD CONSTRAINT [XPKCLASSIF_FISCAL_IMPOSTO] PRIMARY KEY NONCLUSTERED 
(
	[CLASSIF_FISCAL_INICIAL],
	[CLASSIF_FISCAL_FINAL],
	[UF],
	[CODIGO_FILIAL],
	[ID_IMPOSTO]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
sp_bindefault @defname=N'[dbo].[DEFAULT_0]', @objname=N'[dbo].[CLASSIF_FISCAL_IMPOSTO].[ALIQUOTA]' , @futureonly='futureonly'
GO
sp_bindefault @defname=N'[dbo].[DATA_ATUAL]', @objname=N'[dbo].[CLASSIF_FISCAL_IMPOSTO].[DATA_PARA_TRANSFERENCIA]' , @futureonly='futureonly'
GO
EXEC sp_bindefault @defname=N'[dbo].[DEF_CHAR_1]', @objname=N'[dbo].[CLASSIF_FISCAL_IMPOSTO].[CODIGO_FILIAL]' , @futureonly='futureonly'

--ALTER TABLE [CLASSIF_FISCAL_IMPOSTO] ALTER COLUMN CODIGO_FILIAL CHAR(6) NOT NULL

